DECLARE @Store AS TABLE (ID INT PRIMARY KEY IDENTITY(1,1), Store VARCHAR(25))
INSERT INTO @Store (Store) VALUES ('SAFEWAY'),('ALBERTSONS'),('711')
SELECT * FROM @Store

DECLARE @Product AS TABLE (ID INT PRIMARY KEY IDENTITY(1,1), FK_STOREID INT, ProductName VARCHAR(25))
INSERT INTO @Product (FK_STOREID,ProductName) VALUES (1,'TURKEY'),(1,'GRAVY'),(2,'STUFFING'),(5,'GREEN BEANS')
SELECT * FROM @Product


SELECT  *
FROM	   @Store AS S
	   CROSS JOIN @Product AS P

SELECT  *
FROM	   @Store AS S
	   CROSS APPLY (SELECT * FROM @Product AS PSub) AS P
		     
SELECT  *
FROM	   @Store AS S
	   CROSS APPLY (SELECT * FROM @Product AS PSub WHERE S.ID = PSub.FK_STOREID) AS P
	   
SELECT  *
FROM	   @Store AS S
	   OUTER APPLY (SELECT * FROM @Product AS PSub WHERE S.ID = PSub.FK_STOREID) AS P